Role: ETL Informatica Consultant
Location: New York, NY(Onsite)
Job Type: Full Time
Job Description
Knowledge of PL/SQL is Must with hands-on experience.
Understanding the Business Requirements & ETL specification Document
Extraction, Transformation and Loading (ETL) of data by using Informatica PC
Designed various mappings for extracting data from various sources involving flat files and relational tables.
Good Concept of Data warehouse to be available.
Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
Checked and tuned the performance of Informatica Mappings.
Testing and maintaining of Informatica Mappings
Resolving if any issues in transformations and mappings with the help of technical specifications.